Main
Kyle PATRICK Simpson
Data Pipeline Support Specialist | Research Analyst | Data Stakeholder Liason
A results-driven professional with over 5 years specializing in data analytics and pipeline support, proficient in SQL, Python, R, and VBA in Excel for data wrangling, automation, and reporting. Confidently combines analytics with strong interpersonal acumen, administrative efficiency, and a proven ability to quickly secure, validate, and analyze complex data types.
Relevant Work History
Inventory & Quality Assurance Analyst
M2 by Matcha Matcha
Toronto, Ont
2024
- Developed an accurate inventory reporting system using R, SQL, and Excel/Google Sheets via triangulation of sales, purchasing, and inventory records.
- Maintained relational database of supplier, product, and customer information acquired via information requests, exported datasets, APIs, and web-scraping.
- Facilitated working relationships with suppliers to ensure consistency of quality, supply, and pricing.
Data Migration Technician
Lions Foundation of Canada Dog Guides
Oakville, Ont
2022
- Consulted on migration of 4 months financial and client data from Excel & Quickbooks into Salesforce.
- Creation of automated workflows using VBA in Excel for the purpose of data compiling, cleaning, and validation.
- Reached out to individual donor and/or members of the finance team to amend irregularities and/or obtain missing data as required.
Lodgement Administrator
Accident Compensation Commission, NZ
Dunedin, NZ
2022 - 2021
- Demonstrated ability to quickly learn NZ health care policy as it pertains to various work environments and accident coverage.
- Researched and identified various employer entities to ensure accurate attribution of benefits.
- Employed analytical skills to proactively identify and resolve system irregularities and errors.
Managing Director
Bar Squire Beverage Consultancy Services
Wellington, NZ
2021 - 2020
- Provided data driven consultation to bars, restaurants, and events.
- Creation and maintenance of relational databases containing client information, cocktail recipes, product information, bar & restaurant points of service.
- Use of SQL, Excel, R, and Python to wrangle data.
Research Analyst
Greenback Ltd.
Auckland, NZ
2020 - 2019
- Conducted thorough literature reviews of various subjects so as to educate myself and team members on relevant subject matter, data types, and stakeholders.
- Identified various sources of private and publicly available environmental data via information requests, web-scraping, and API pulls.
- Collaborated directly with the application development team on data implementation and structuring.